"Vlookup" to search in multiple columns

		Microsoft Office Forums > Microsoft Excel > Excel
"Vlookup" to search in multiple columns

FAQ

Thread Tools

Display Modes

08-08-2016, 08:35 AM

oolourdesoo oolourdesoo is offline

Windows 7 32bit "Vlookup" to search in multiple columns

Office 2013

Novice

Join Date: Aug 2016

Posts: 1

"Vlookup" to search in multiple columns

Hello. I usually use vlookup to search in one column, but I need my function to search in multiple columns. How can I do that.

I usually would use

=vlookup(G2,Sheet8!K:L,2,false)

but instead of just looking in column K and displaying what is in column L, i need to searching in columns D to K and then display what is in column L.

Thank you in advance,

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spreadsheet with "CR" & "DB" in amount & number columns.	bfisher	Excel	4	09-28-2015 07:03 AM
vlookup yeilds "weird" results...	markjkubicki	Excel	3	05-07-2015 12:54 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Instant Search's "Display search results as I type when possible" with Exchange	lwc	Outlook	0	06-01-2011 01:56 AM
How do I change the "and" to "or" with multiple Rules (and Alerts)?	bschimmel	Outlook	0	11-16-2009 05:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.