# 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
jppinto

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Paste this in Cell L2

=IF(ISERROR(VLOOKUP(B2,Database!A:H,2,0)),"-",VLOOKUP(B2,Database!A:H,2,0))

M2

=IF(ISERROR(VLOOKUP(B2,Database!A:H,3,0)),"-",VLOOKUP(B2,Database!A:H,3,0))

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

Sid
xover

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
put that in L2 and copy that formulas everywhere you need it
=VLOOKUP(\$B2,Database!\$1:\$65536,COLUMN(B1))
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.