look up value from one sheet input to another

[sendtobrad]

I have a worksheet where the first tab; Sheet1, contains product numbers in column A and nouns (product names) in Column B.
the second tab (crazy long name) has product numbers in column A, needs the noun from Sheet1 in column B, and loads more columns.

How can I get the program to search Sheet1 for the value in all the A cells on the second tab and populate Column B with the corresponding value from Sheet1 ColumnB?

[jeffreybrown]

How about a vlookup

[sendtobrad]

=VLOOKUP(A2,Sheet1!$A$2:$B$1849,2,False)

I tried this but it is just sitting there not executing.

[Cutter]

That would be the correct formula. When you say it is just sitting there do you mean you see the formula in the cell? Or the formula is visible only in the formula bar when the cell is selected but there is no result in the cell?

If the former you likely have the cell formatted as text. Format to general (or whatever).
If the latter you likely have calculation set to manual. Set it to Automatic.

[Point5]

Try leaving the range_lookup Blank - This worked for me when I used VLUP's

[Cutter]

Omitting the FALSE is equivalent to using TRUE. Not usually a good idea as it can give incorrect results.

http://www.excelfunctions.net/ExcelVlookup.html

[sendtobrad]

That would be the correct formula. When you say it is just sitting there do you mean you see the formula in the cell? Or the formula is visible only in the formula bar when the cell is selected but there is no result in the cell?

If the former you likely have the cell formatted as text. Format to general (or whatever).
If the latter you likely have calculation set to manual. Set it to Automatic.[/QUOTE]

I did have the cells formatted as text and have made the changes. It is working for many columns now. In most of the others I get #NA. It is a huge file and I am not going to check if each #NA is corresponding to a number which is not in the referenced file. Thanks for the help