If I understand your description correctly, you want the VLookUp formula to
return multiple answers (equal to the number of rows in sheet1 that contain
a "Yes" in ColA.
As far as I know (and that's not all that far :), the VlookUp will only
return one answer, i.e. as soon as it finds a match it stops.
If I'm right, then I think that you'll need to add a helper column to create
a unique "Counter" type of value for each "Yes" row. Then on your sheet2
you'll be able to do a table to extract all the "Yes" rows on the basis of
the unique "Counters".
If you don't get a better answer, and you need some help implementing my
suggestion, let me know.
Rgds,
ScottO


"StephenAccountant" wrote in
message ...
| How do i use Vlookup for 100 rows when what I am searching for in the
vlookup
| is the same refernce? EG:
|
| Cell A1 is a heading.
|
| In Cells A2 through to A101 I may or may not have a value. In fact I will
| usually only have about 2 or 3 of these cells with a value. The value is
the
| text - Yes.
|
| Now I have a formula that depending on if there is a Yes in the A column
| then in my D column it will return a value.
|
| So on my second worksheet I want to have Vlookup formula for the 100 rows
| on my first worksheet where I look for the Yes in column A and then return
| the value in Column D.
|
| But this doesn't work when I am referenceing the same thing in Column A.