Help writing a VLOOKUP formula

[j4ymf]

Hello

Could you please help me write a VLOOKUP formula
what i am after is if D5 cell is greater than the range of any B13 - O13 then the result is the next value

Results in F4, F6, F8

Hope this makes sence
many thanks

Jay

 

[Fluff]

Which column do you want to return?

 

[j4ymf]

Hi Fluff

I need to match the S in Cell C10 from the range A2:A4 then do the same formula you gave me before.

so if i had an S it would give me £6.00 nut if i had a D it would give me £10.80 and a C it would give me £25.00

Thank you

 

[j4ymf]

Fluff

Please find below a picture as im trying to create a tally sheet

 

[Fluff]

But what determines which column you should get the £6 or £10.80 from?

 

[j4ymf]

Fluff

Row 10
F10 has a forumla of ( =D10*E10/1000000 ) which gives me the result of 0.12

G12 looks at column F which has the formula (=XLOOKUP($F$10,$B$1:$O$1,B2:O2,"",1)
so instad of just matching F10 i need to match C10 aswell with the range of A1:O4

thank you

 

[j4ymf]

F Determines my result

 

[Fluff]

Ok, how about

=INDEX($B$2:$O$4,XMATCH(C8,$A$2:$A$4,0),XMATCH(F12,$B$1:$O$1,1))

 

[j4ymf]

Fluff

You are so cleaver, thank you so much once again

 

[Fluff]

You're welcome & thanks for the feedback.

 

[jasonb75]

Looks like I was a bit late getting back to the party, but thought I'd throw another one in anyway,

=LOOKUP(F12,$B$1:$O$1,INDEX($B$2:$O$4,XMATCH(C8,$A$2:$A$4,0),0)