can any1 help me about this vlookup?

LMF

Board Regular
Joined
Mar 16, 2002
Messages
73
i have used vlookup many times in one formula and is wondering if there is any alternative function that i can use to minise it.

anyone?
This message was edited by LMF on 2002-04-12 05:51
This message was edited by LMF on 2002-04-12 05:51
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Not a lot of detail to go on, but, how about putting the vlookup in another cell then reference it from your formulae

Good luck
 
Upvote 0
but to be honest, that won't really make a difference will it?

:)

how about using DGET or INDEX ???

does it work the same as vlookup?
or similar?

lmk

thanks
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top