reference vlookup cell
HI... Is there a way to reference a cell after using Vlookup. IE: a2 10 b2 d a3 14 b3 e a4 39 b4 f c5 14 d5 = vlookup(c5,a2:b4,2,false) ...result 'd' Now I want to be able to determine the cell was 'b3' Thanks!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
reference vlookup cell
=Match(C5,A2:A4,0)
will give you 2 since it is the second cell in the column of cells A2:A4 Since you know the range starts in A2, you could add 1 to that to get row 3 and you already know the value is in column B. ="B" & Match(C5,$A$2:$A$4,0)+1 -- Regards, Tom Ogilvy "hef" wrote in message ... HI... Is there a way to reference a cell after using Vlookup. IE: a2 10 b2 d a3 14 b3 e a4 39 b4 f c5 14 d5 = vlookup(c5,a2:b4,2,false) ...result 'd' Now I want to be able to determine the cell was 'b3' Thanks!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com