LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
James
 
Posts: n/a
Default Vlookup of an if statement return

Hey all,

Ok here is what I am trying to do.

I have a sheet that in the first column I have an "if" statement that will
either level the blank empty or return the value "Overdue"

On a second sheet I want to be able to use VLookup or a similar function to
be able to check column "a" on my first sheet for all references to Overdue
and return the corrosponding value in column "b".

The problem I am having is that I can find the first "Overdue" and get my
column "b" text but I want to set it up to go on and find the next one and
then the next.

If this is not clear enough let me know and I will try to provide more
information.
--
James
 
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
Vlookup - return row no. instead of value automne Excel Discussion (Misc queries) 2 March 7th 05 12:38 AM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 07:03 AM
If/And statement; VLOOKUP? o1darcie1o Excel Worksheet Functions 5 December 29th 04 05:22 PM
Extension of and IF & VLOOKUP statement Sal Excel Worksheet Functions 1 December 20th 04 04:19 AM
VLookup Return Value Kevin Excel Worksheet Functions 4 December 3rd 04 03:05 PM


All times are GMT +1. The time now is 03:01 AM.

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

About Us

"It's about Microsoft Excel"