I have following data in my sheet. (please see below)
Rows A B C F
G---col
1 CODE AMT CODE_2 CODE K12----headings
2 SS 50 K12 SS
3 DD 20 S12 DD
4 FF 30 K12 FF
5 GG 10 E12 GG
6 HH 44 T12 HH
7 JJ 60 T12 JJ
8 KK 66 V12 KK
9 UU 70 S12 UU
10 PP 80 Y12 PP
11 ZZ 90 P12 ZZ

I want formula in in cell "G2" which should match or lookup value of
cell "G1" in range "C2:C11" and then match or lookup value of cell
"F2" in range "A2:A11" and then bring up value from range "B2:B11" .
Like in above table formula should bring value "50" in cell "G2" from
column "B".
I want formula something like this "lookup(G1 in C2:C11 then F2 in
A2:A11 then bring value from column B). I hope I explained what I am
trying to say. Please if anybody can help.

Hi,

I'm sure someone can help but i'm not clear what you are asking.

Are you looking to lookup a value in a range and then return a value
in another column on the same row where it was found?

Eg lookup K12 in a2:f11. If the value of K12 is found in a7 return the
value in b7

If not please try and explain again.

On 11 Apr, 22:48, anon wrote:
Hi,

I'm sure someone can help but i'm not clear what you are asking.

Are you looking to lookup a value in a range and then return a value
in another column on the same row where it was found?

Eg lookup K12 in a2:f11. If the value of K12 is found in a7 return the
value in b7

If not please try and explain again.

look K12 in range(C2:C11) and SS which is in cell F2 in range(A2:A11)
then bring value from range(B2:B11)
the value should come 50 as if you see above table in row 2 we have SS
in cell A2 and K12 in cell C2 so formula should pick cell B2 value
which is 50. Basically with vlookup you lookup on value and then bring
the answer but i want some formula which should lookup 2 values same
time and then bring the result. i hope you understand what i am tring
to say.

OK got you.

=IF(AND(VLOOKUP(G1,C2:D11,1,FALSE)=G1,VLOOKUP(F2,A 2:B11,1,FALSE)=F2),VLOOKUP(F2,A2:B11,2,FALSE),
0)

On 11 Apr, 23:18, anon wrote:
OK got you.

=IF(AND(VLOOKUP(G1,C2:D11,1,FALSE)=G1,VLOOKUP(F2,A 2:B11,1,FALSE)=F2),VLOOKU*P(F2,A2:B11,2,FALSE),
0)

Thanks for replying anon. i tried your formula and its work fine but
when i drag this down it not working the way i want. the formula
should only bring value from the row where both other value matches.
it works fine in G2 cell but as i go down draging the formula its not
working. any help you can give on this. thanks

That's because the formula will be changing the ranges you're
searching in, look carefully at what has happened when you drag it
down, you will see G1 has changed to G2 or G3 etc, as will all of the
cells you have dragged it to. You need to put a $ in front of the
cells you don't want to change.


=IF(AND(VLOOKUP($G$1,$C$2:$D$11,1,FALSE)=$G$1,VLOO KUP($F$2,$A$2:$B
$11,1,FALSE)=$F$2),VLOOKU**P($F$2,$A$2:$B$11,2,FAL SE),0)

Suggest getting a good excel book to learn the basics of this
otherwise it'll be slow going for you to do your spreadsheet.