ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Vlookup inside a formula (https://www.excelbanter.com/excel-worksheet-functions/230815-vlookup-inside-formula.html)

willemeulen[_4_]

Vlookup inside a formula
 

Is it possible to use a vlookup funciont inside a formula?

:Bgr


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96511


Mike H

Vlookup inside a formula
 
Hi,

Yes that's possible and if you give an example of what your trying to do
then someone will help.

=IF(A1=999,VLOOKUP(B1,C1:D30,2,FALSE),"I didn't do the Vlookup bit")

Mike

"willemeulen" wrote:


Is it possible to use a vlookup funciont inside a formula?

:Bgr


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96511




All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com