Jump to content

VLOOKUP HElp


This topic is 3028 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello,

I need help creating a VLOOKUP formula for the following situation. I have two tables on sheet. I want a VLOOKUP formula that will compare the data in COlUMN A to the data in COLUMN N. If the data matches exactly, I want measurements (COLUMN O) to be entered into COLUMN G (TABLE 1) and the Weight (COLUMN P) to be entered into Column F (TABLE 1). Can someone help me out with this? Please check out my attachment. 

 

Thank you!

698798.png

Link to comment
Share on other sites

For starters, this is a FileMaker forum. Not an excel forum. :)

With that said, see if this works. ( note in your screen shot it looks like the labels are backwards or the data is in the wrong column ). You will need to adjust the formula based on the size of the tables. You could also convert the "tables" to actual Excel table, then you can reference the table/column name and it will auto adjust as the table grows.

Ship Weight =VLOOKUP(A2,$N$2:$P$7,3,0)

Dimensions =VLOOKUP(A2,$N$2:$P$7,2,0)

Link to comment
Share on other sites

Hello ycast and welcome to the FM forms,

I find it unusual that a new member first post post uses an Excel spreadsheet as part of their description :-).

Since you posted this in the custom functions,  by chance, did you look at the two custom functions available at Brian Dunning site? If so, is this what you’re looking for?

 Lee

Link to comment
Share on other sites

This topic is 3028 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.