Posted to microsoft.public.excel.worksheet.functions
|
|
retrieve data from two columns and sort
Works like a champ! You're the Man!
"Glenn" wrote:
Joe wrote:
Well I got it to kinda work. If you get a chance would you see what is wrong
with it?
http://www.savefile.com/files/1987705
Thank you.
Try this:
=IF(ISNUMBER(MATCH(B5,$G$5:$G$14,0)),INDEX($F$5:$F $14,MATCH(B5,$G$5:$G$14,0)),INDEX($F$5:$F$14,MATCH (B5,$H$5:$H$14,0)))
|