give a value based on data found in a column - put need a value from it's row

I am stuck. I have a ton of data. on one worksheet (lets call it worksheet A) i have a list of merchant's name and data on the merchant in a row (e.g. category) on another worksheet (lets call it worksheet B) i have another list of merchant's name and no category listing for them. i want to create a new column in worksheet B called category and i want to be able to tell that box, if name in this worksheet B equals the name in Worksheet A, Column 1 then the category assigned to that name will appear in this box. (this is very easy to merge in access but have to find solution for excel)

i have condenced it down to one worksheet with three listings. any help would be greatly appreaciated.

Based on the example provided, you could also try using the VLOOKUP function.

Please Login or Register  to view this content.

Where D2:D4 is your lookup array, A2:B6 is your array table, if match return column 2 data, 0 = exact match. You can easily tweak the above code if your data lies across different sheets--simply highlight/select desired cells for both the lookup array and the array table.

Cheers,
Jimmie

thank you. the vlookup was exactly what i needed. so simple. i knew it would be. thank you. i really appreciate it.