sarkocreme
New Member
- Joined
- Dec 14, 2009
- Messages
- 9
I have a table that looks like this:
<tbody>
</tbody>
The vlookup where it's seeking (worksheet!$A1:$B4) this looks like:
<tbody>
</tbody>
In the cases of rows #1 and #4 I want to return "refrigerator" for the INDIRECT formula. As written it will return "1" and "4" respectively since it runs relative to its local position. How can I run it local to the vlookup?
refrigerator | =vlookup(randbetween(1,4),worksheet!$A1:$B4,2,false) |
<tbody>
</tbody>
The vlookup where it's seeking (worksheet!$A1:$B4) this looks like:
1 | "Buy a "&INDIRECT(ADDRESS(ROW(),COLUMN()-1))&" from us" |
2 | "Everything we sell is great" |
3 | "The best warranty ever" |
4 | Best "&INDIRECT(ADDRESS(ROW(),COLUMN()-1)) |
<tbody>
</tbody>
In the cases of rows #1 and #4 I want to return "refrigerator" for the INDIRECT formula. As written it will return "1" and "4" respectively since it runs relative to its local position. How can I run it local to the vlookup?