VLookUP Formula

[Shazz]

Hi All,

I want to be able to click on a Supplier in the drop down menu on the PO Tab and all the address details are pulled through onto the cells under the supplier name, I know this is possible but I cant work out how to do this. I do not have an option to upload an example but I can PM one to you.

Can someone help at all??

Shazz
x

 

[RCBricker]

Hi All,

I want to be able to click on a Supplier in the drop down menu on the PO Tab and all the address details are pulled through onto the cells under the supplier name, I know this is possible but I cant work out how to do this. I do not have an option to upload an example but I can PM one to you.

Can someone help at all??

Shazz
x

not sure if this is what you want.

1. create your drop down list
1.A. DATA tab then Data Validation
1.B. Change Allow: drop down to list then type in your supplier names.
2. write your Vlookup using the cell with the drop down as your lookup value (use an absolute reference so that it doesn't change as you copy and paste the formula to other cells)

sample formula:

=IF(ISERROR(VLOOKUP($A$1,$R$3:$W$5,2,0)),0,VLOOKUP($A$1,$R$3:$W$5,2,0))

I used an if(iserror here to return a 0 if there is an error in the formula.

you can get by without it if you don't mind the #NA error being returned.