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,Datab ase!$A$1:$ H$4,2;FALS E)),"",VLO OKUP($B2,D atabase!$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,COLU MN(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