carl

Posts: n/a

LookUp Type Question

I have a table like so:

ColA ColB
ABC 2
EFG 1

Is there a formula that will look down ColA and if there is a match, return
the value in ColB, but if there is not a match in ColA, return a blank.

Thank you in advance.

Carl

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
Lookup Question	Brad P	Excel Worksheet Functions	3	June 5th 05 12:08 AM
Lookup Type Question	carl	Excel Worksheet Functions	1	March 8th 05 08:30 PM
Formula Question... LookUP	G	Excel Discussion (Misc queries)	4	March 7th 05 01:38 AM
Multiple Criteria Lookup Question	Gregg Riemer	Excel Discussion (Misc queries)	3	February 22nd 05 01:18 AM
Lookup Question	Mackay 1979	Excel Worksheet Functions	2	February 19th 05 01:11 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us