Value copied based on choosen value from combo box

[AA Arens]

I do have two sheets SheetA and SheetB


SheetA

111 100
222 200
333 300
444 400


SheetB

Consists of combo box for 1st column. After choosing value, the
corresponding value in the neighboring column from sheetA is copied.

333 X
222 X
444 X

Sample:

444 400

What is the formula is the X cells, it should be with MATCH or COUNT /
COUNTIF but I cannot get the right formula.

Bart
Excel 2003






How to have a value being copied to another sheet?

 

[Roger Govier]

Hi

One way, in cell B2 of Sheet2
=VLOOKUP(A2,Sheet1!$A$1;$B$100,2,0)
copy down as far as required.

Change the range A1:B100 to include all the values from your range on
Sheet1

 

[AA Arens]

May I use VLookups when the value is not found in sheet1 but could be
found in sheet 3 and 4?

Bart

 

[Roger Govier]

Just change the reference to Sheet2 or Sheet3 as appropriate

=VLOOKUP(A2,Sheet2!$A$1;$B$100,2,0)