Pick cell based on multiple cells

**rdd2** · 02-05-2009, 03:32 PM

I want the 'Model Number' to automatically be picked based on the numbers entered into Sheet1 B1 & B2. The model numbers are listed on Sheet2. Can someone help me with this?

**VBA Noob** · 02-05-2009, 03:38 PM

Please in future save as xl03

I added a helper column to sheet 2 and use a vlookup formula

=VLOOKUP(B1&B2,Sheet2!A:D,4,FALSE)

VBA Noob

**NBVC** · 02-05-2009, 03:41 PM

tRY:

Please Login or Register  to view this content.

Once entered, confirm it with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula.

**rdd2** · 02-05-2009, 04:06 PM

Thank you very much! Have a nice afternoon!!

**VBA Noob** · 02-05-2009, 04:07 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save