conditional vlookup

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
conditional vlookup

Reply

#1

Old

02-23-2012, 03:40 AM

ishfaq

ishfaq is offline

conditional vlookup

Windows XP conditional vlookup

conditional vlookup

Office 2007

Novice

conditional vlookup

Join Date: Feb 2012

Posts: 1

ishfaq is on a distinguished road

Default

conditional vlookup

Dear all.
i want to lookup the rate in work sheet - 2 if Group and Item matched.
plz see the attached file and reply.

Attached Files

conditional lookup.xls (20.5 KB, 15 views)

Reply With Quote

#2

Old

02-23-2012, 07:36 AM

Pecoflyer

Pecoflyer is offline

conditional vlookup

Windows XP conditional vlookup

conditional vlookup

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Pecoflyer has a reputation beyond repute

Default

Perhaps =LOOKUP(2,1/($D$8:$D$32&$E$8:$E$32=H11&I11),$F$8:$F$32) and pull down as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Reply With Quote

Reply

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
Vlookup	ibrahimaa	Excel	8	01-03-2012 09:32 PM
Can i do this with a VLookup?	foodstudent	Excel	1	01-21-2011 12:34 AM
Using IF & VLOOKUP together	junction	Excel	7	11-18-2010 05:15 AM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 AM.