Combine vlookup and if

[ganeshm]

hi...

Is it possible to combine both conditions in one cell. sample sheet is attached for your perusal.

regards,
ganeshm

 

[Somendra Misra]

@ganeshm

What will be input cell?

Regards,

 

[Somendra Misra]

Use below formula in B3

=IF(B4>0,VLOOKUP(B4,Sheet2!A2:B47,2,0),"")

Regards,

 

[ganeshm]

Hi Somendra,

input cell in B3 in sheet 1 (which is 24816)

in cell B4 answer is 29 (calculation: 24816/12 = 2068) - (corresponding range of 2068 is 29).


regards,

 

[Somendra Misra]

@ganeshm

Use below formula in B4: which is returning 29
=IFERROR(INDEX(Sheet2!A2:A47,MATCH(B3/12,Sheet2!B2:B47,0)),"")

Regards,

 

[ganeshm]

i just didn't realize i should use index formula.

Thanks. It works.
Finally, something specific is learnt for the day.

Regards,
ganeshm

 

[Somendra Misra]

@ganeshm

Glad you solve it.

Regards,

 

[Faseeh]

This can also be tried:

=LOOKUP(B3/12,Sheet2!B2:B47,Sheet2!A2:A47)

 

[SirJB7]

Hi, ganeshm!
Next time please post here the issue description, keeping it into your workbook too if you consider it propertly.
This will help users who read this to decide whether they'd be able or want to analyze it further, without having to download/open any file.
Regards!