IF, and Vlookup, and a variable

R

raylee011

Hello,

I have a little problem. I have 2 spreadsheets. I am doing my best t
explain my situation.

I have 2 spreadsheets. I need to compare some value in between to get
result.
let says for example.

1. A value in Spreadsheet A.
on the Spreadsheet B, there is a column full of value that the valu
in Spreadsheet A can match with. The value of A show many time in
column B of Spreadsheet B. Now, lets say, column A row 10 (A10) find
match in Column B (B20) in Spreadsheet B, now I need use the value in
cell C (C20) in Spreadsheet B matches again a (D10), if they match
will need to take a value in Spreadsheet A same row (E10) match agains
Spreadsheet B Cell(F20). If it match, i need it to return a value fro
spreadsheet B cell(K20).

Do you understand my question??
Or can anyone explain to me in detail about the
if
if then
vlookup
or even put the return value into a variable.

Thank
 
F

Frank Kabel

Hi
o.k. lets try
=IF(ISNA(MATCH(A10,'sheetB'!B1:B100,0)),"",IF(VLOOKUP(A10,'sheetB'!B1:C
100,2,0)=C10,IF(VLOOKUP(A10,'sheetB'!B1:F100,5,0)=E10,VLOOKUP(A10,'shee
tB'!B1:K100,10,0),"")
,""))
 
D

Dave Peterson

Look for an exact match for A10 in B1:b100 of sheetB.
If you find an error (isna() looks for #n/a errors), then just show ""
but if you found a match, then do a vlookup and return what's in column
C
If that value is the same as in C10, then keep looking.
If the value in F1:F100 matched E10, then keep looking once more.
bring back the value from K1:K100.

If all that fails, show "".
 
Top