Simple Range Lookup

[thilag]

Hello Friends

Please find the attached 2013 version file <Range Lookup 181015>.

I want to plot the value in Cell N3 in Sheet `SH' by looking from Sheet `SBC N' Colimn I and J and take the value from respective column C and plot the value in Sheet `SH' in light yello cells.

thanks in advance

thilag

[samba_ravi]

=lookup($m3,'sbc n'!$i$3:$i$114,'sbc n'!$c$3:$c$114)

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.