Posted to microsoft.public.excel.misc

external usenet poster

Posts: 157

IF VLOOKUP & CONCATENATE

Can someone help me please? Need to know, how would I put into a formula, if
$B3=0, then leave cell blank, otherwise, look-up cell A3 on sheet 2 from
B2:B572, and if a match is found, concatenate from sheet 2 cells O3, P3 and
Q3.

This is the formula I have as far as I could go with it, but didn't know how
to get the concatenate part in there

=IF($B3=0,"",VLOOKUP($A3,'sheet 2'!$B$2:$U$572,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CONCATENATE & VLOOKUP	David Brereton[_2_]	Excel Discussion (Misc queries)	4	August 28th 08 09:36 AM
Concatenate a VLOOKUP	lehigh46	Excel Worksheet Functions	2	August 27th 08 08:58 PM
Vlookup & Concatenate?	Saxman[_2_]	Excel Discussion (Misc queries)	14	July 30th 07 02:24 PM
Concatenate and Vlookup	Lynneth	Excel Worksheet Functions	8	September 10th 05 09:02 PM
Can you use Concatenate with the If function with vlookup in the i	simoneaux	Excel Worksheet Functions	2	February 7th 05 08:45 PM

All times are GMT +1. The time now is 08:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us