Link to home
Start Free TrialLog in
Avatar of zyanj
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
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.