Lookup function

[sowetoddid]

I think this is a fairly easy one..

I have two sheets.

Sheet 1 has column C with 226 rows of ID numbers. Column E has the 22
corresponding descriptions. This list will grow to 300 or more value
eventually.


Sheet 2 has only the same ID numbers from Sheet 1 but in a random orde
listed in column B. I would like column A to be automaticall
populated with the corresponding descriptions.


If-then was my first thought, but I realize only 7 statements can b
nested. Don't know too much about lookup...


Thanks

 

[Frank Kabel]

Hi
put the following in A1 on your second sheet
=VLOOKUP(B1,'sheet1'!$A$1:$B$400,2,0)
and copy down

 

[sowetoddid]

This is the attempt I have made using Index and Match (from example i
another thread)...


In cell A1 and copied to A300:

=INDEX('Sheet1'!$C$1:$C$300,'Sheet1'!$E$1:$E$300,MATCH(B1:B500,'Sheet1'!$C$1:$C$300))


Thanks

 

[sowetoddid]

Thanks, Frank.

Well, I tried to keep it simply by leaving out that the referenc
values are in another workbook [Master List]. So, 'Sheet1' is actuall
in the [Master List] workbook.

When I tried this equation, it did not work.


Please help again

 

[sowetoddid]

Ok, ok....thanks, Frank.


It was my own mistake. It does work now.


Now, Something weird is happening.....

Every few lines says #N/A. If I go to the [Master Inventory], selec
that value, then go back to the VLOOKUP formula, it works.


Why?

 

[Frank Kabel]

Hi
sounds like some values are not stored as numbers but as Text. Try the
following on your master inventory sheet:
- select an empty cell
- select the range with your values
- goto 'Edit - Paste Special' and choose 'Add'