vlookup Function Help Needed

[jeffc]

All,

I've been working on this for 2 days now and can't figure it out so an
help would be appreciated.

I have one workbook with multiple tabs on it. Tab A has multipl
columns being used but columns A and B are the important ones. Column
is labeled Sample Number and starts off blank. Column B is labeled Ro
number and is in ascending order from 1 to whatever.

Tab B has two columns on it. Actually there are more but they aren'
important to what I'm doing. I hope. Column A is labeled Sampl
Number and is a list of random numbers. Column B is the correspondin
Row Number on tab a that the sample number is associated with.

For example Tab B

Sample Number Row Number
113 95
178 110
and so on. The row numbers are generated in acceding order.

What I'm trying to do on Tab A in Column A(Sample Number) i
automatically bring over the sample number from Tab B and place it o
the correct row. If there is no sample number for the row I want th
cell to be blank which I will end up doing use the IF function and th
ISNA function.

I've tried using the match function with the vlookup function but no
cigar.

Hopefully this makes sense.

Thanks
Jef

 

[Per Erik Midtrød]

Hello Jeff.

If I have understood your problem correctly you could solve ut using a
combination of Match and Index, try pasting this formula in A2 on
sheetA:
=INDEX(B!A:A;MATCH(B2;B!B:B;0);1)

Best regards
Per Erik

 

[jeffc]

Erik,

Your formula worked perfectly. This really saved me a lot of work.
Now I don't have to enter 1069 numbers manually.

Thanks!
Jeff

 

[Zoddy]

If your two tabs are identical as to the ROW numbers can you not just link the cells of the sample numbers on tab A to those on tab B?

HTH

Zoddy

 

[Zoddy]

If you do want a VLOOKUP version try this

Enter this in cell A2 on tabA

=IF(ISNA(VLOOKUP(B2,tabB!A:B,2,FALSE))= TRUE,"",VLOOKUP(B2,tabB!A:B,2,FALSE))

For this to work the range the VLOOKUP uses on tabB (A:B) will have to be reversed ie Col A will have to be Row number and Col B the Sample number.

To get rid of any Zero's in col A tabA you could turn off 'Zero values' in Tools > Options > View

HTH

Zoddy