Looking for help with lookups -- I think

[VRM]

Hi Folks,
First, thank you for the assistance. This forum is invaluable.

I have 2 workbooks. In workbook A I have one entry per RecID. In workbook B, I have multiple entries per RecID.
I need to see the entry from workbook A and all associated entries from workbook B.
And, I know NOTHING about lookups other than they seem to be the approach I need to take.
I am open to suggestions as to approach.

Again, thanks.

 

[JWick]

You could work backwards and do a vlookup from workbook B to workbook A, then once complete, sort workbook B by the vlookup column (from workbook A) to get all associated RecIds in workbook A. Also if you know there may be RecId's in workbook A without RecIDs in workbook B you could do a vlookup from A to B and any #N/A's would not be in B.

 

[VRM]

Hi Folks,

When I put in my function

=VLOOKUP(A2,ContestPhoto!A:B,2,FALSE)

, I get #N/A
My worksheet has multiple columns, the vlookup formula is in column K, but I get a caution tag in column J that reads, "A value is not available to the formula or function."
As I have stated, I know nothing about vlookups.
Do columns containing the formula need be in a certain location?
My worksheet goes from A to J, so I put the formula in column K.

Thanks.

 

[JWick]

If the value in column A (cell A2) is the RecID, then your column A in "Contest Photo" should also be the RecID column - if it isn't then you need to update your vlookup to ensure the RecID column is the first column of your reference to the "ContestPhoto" tab. The way your formula appears now, you are looking up on column A, but pulling in the data in column B of "ContestPhoto" without having a visual understanding of your workbooks, I can't tell if this is what you are trying to do or not. If column B is the RecID column, you just need to update your formula to =VLOOKUP(A2,ContestPhoto!B:B,1,FALSE)

 

[VRM]

If the value in column A (cell A2) is the RecID, then your column A in "Contest Photo" should also be the RecID column - if it isn't then you need to update your vlookup to ensure the RecID column is the first column of your reference to the "ContestPhoto" tab. The way your formula appears now, you are looking up on column A, but pulling in the data in column B of "ContestPhoto" without having a visual understanding of your workbooks, I can't tell if this is what you are trying to do or not. If column B is the RecID column, you just need to update your formula to =VLOOKUP(A2,ContestPhoto!B:B,1,FALSE)

I found that the "linking" column must be the left most column in the range or table.