zyanj

asked on

# Excel Update info from another sheet

I have one tab that holds my database information and another tab that references it. I need the data on the first tab to automatically fill in the columns to the left based upon the Resource and the Intr# (see spreadsheet)

I believe =IF(ISNA(VLOOKUP is what I am looking for but don't know how to do it

Thanks so much

Sample.xls

I believe =IF(ISNA(VLOOKUP is what I am looking for but don't know how to do it

Thanks so much

Sample.xls

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

xover

Sid

Sid

Your formula, for the first column, will be:

=IF(ISNA(VLOOKUP($B2,Database!$A$1:$H$4,2;FALSE)),"",VLOOKUP($B2,Database!$A$1:$H$4,2,FALSE))

For the next columns, you need to change the 2 for 3, 4, etc, to get the values from the corresponding columns.

jppinto

=IF(ISNA(VLOOKUP($B2,Datab

For the next columns, you need to change the 2 for 3, 4, etc, to get the values from the corresponding columns.

jppinto

put that in L2 and copy that formulas everywhere you need it

=VLOOKUP($B2,Database!$1:$65536,COLUMN(B1))

=VLOOKUP($B2,Database!$1:$

i would use jppinto solution, but instead of changing the number for 2, 3, 4, etc... i would do a ref like i did to COLUMN(B1). This way it will automatically increment as you copy the formula.

=IF(ISERROR(VLOOKUP(B2,Dat

M2

=IF(ISERROR(VLOOKUP(B2,Dat

and so on. Just increase the number so next one will be 4

Sid