how to put VLOOKUP into IF function

choungeehowe · Mar 4th, 2002, 01:07 AM

this is what i have

SHEET 'Reference'
Clients____Online$____Traditional$
10_________$500__________$280
20_________$400__________$200
50_________$250__________$150

SHEET B
Mode________No.of Clients___Charge per Client
Traditional______22
Traditional______12
Online__________20
Online__________33

how do i get the Charge per client? this is what i have inputted as my formula
=IF(A1=Traditional, (VLOOKUP(B2,Reference!A2:C4,3)), (VLOOKUP(B2,Reference!A2:B4,2)))

[ This Message was edited by: choungeehowe on 2002-03-04 00:11 ]

Mudface · Mar 4th, 2002, 03:03 AM

Nearly there, you just need to put inverted commas around Traditional and maybe change one of your lookups-

=IF(A2="Traditional", (VLOOKUP(B2,Reference!A2:C4,3)), (VLOOKUP(B2,Reference!A2:C4,2)))

choungeehowe · Mar 4th, 2002, 03:06 AM

hey kewl ... thanx ... fergot the inverted commas ... no wonder

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 01:07 AM	#1
choungeehowe New Member Join Date: Mar 2002 Posts: 13	this is what i have SHEET 'Reference' Clients____Online$____Traditional$ 10_________$500__________$280 20_________$400__________$200 50_________$250__________$150 SHEET B Mode________No.of Clients___Charge per Client Traditional______22 Traditional______12 Online__________20 Online__________33 how do i get the Charge per client? this is what i have inputted as my formula =IF(A1=Traditional, (VLOOKUP(B2,Reference!A2:C4,3)), (VLOOKUP(B2,Reference!A2:B4,2))) [ This Message was edited by: choungeehowe on 2002-03-04 00:11 ]

Mar 4th, 2002, 03:03 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Nearly there, you just need to put inverted commas around Traditional and maybe change one of your lookups- =IF(A2="Traditional", (VLOOKUP(B2,Reference!A2:C4,3)), (VLOOKUP(B2,Reference!A2:C4,2)))

Mar 4th, 2002, 03:06 AM	#3
choungeehowe New Member Join Date: Mar 2002 Posts: 13	hey kewl ... thanx ... fergot the inverted commas ... no wonder