Lookup function

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

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
 
Hi
put the following in A1 on your second sheet
=VLOOKUP(B1,'sheet1'!$A$1:$B$400,2,0)
and copy down
 
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
 
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
 
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?
 
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'
 
Back
Top