ExcelBanter - matching data from column b

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - matching data from column b (https://www.excelbanter.com/excel-worksheet-functions/57061-matching-data-column-b.html)

tbax6

matching data from column b

Have created a worksheet with a drop down box containing data from seperate
worksheet's column A and need to show the matching data in column B.
Suggestions?

bpeltzer

matching data from column b

=vlookup(dropdown_cell,other_sheet!A:B,2,0)

"tbax6" wrote:

Have created a worksheet with a drop down box containing data from seperate
worksheet's column A and need to show the matching data in column B.
Suggestions?

All times are GMT +1. The time now is 03:58 AM.