Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 8
Default

Quote:
Originally Posted by Spencer101 View Post
Have a look at the attachment. Does this clear things up?

It would be a case of just a straightforward VLOOKUP if your C and D columns were the other way round, but as they're not I've used CHOOSE to do a "left lookup".

Let me know if you need any of it clarified.
Excellent! Thank you.
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Jenniferpod View Post
Excellent! Thank you.
Not a problem. Glad I could help. :)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
If find function to not find anything Carlos Excel Programming 4 February 14th 08 09:25 AM
Help with Find function Extropian Excel Programming 3 May 30th 07 04:14 PM
Find function Kris Excel Programming 2 September 27th 06 10:00 AM
Find function Jahunga Excel Worksheet Functions 2 November 22nd 04 03:38 PM
backwards find function to find character in a string of text Ashleigh K. Excel Programming 1 January 14th 04 04:36 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"