close

I have a list of 120 items that I have to search for amongst 5 list of data
on 5 different worksheets. Is there a way of searching for them all in one
go across the 5 worksheets? using individual lookups would take an age!and ideas anyone?
Are the ranges for your lookup tables in the same location for each
sheet?

What are the ranges for your tables?

How are your sheet tabs named?

In article gt;,
quot;jiwolfquot; gt; wrote:

gt; I have a list of 120 items that I have to search for amongst 5 list of data
gt; on 5 different worksheets. Is there a way of searching for them all in one
gt; go across the 5 worksheets? using individual lookups would take an age!
gt;
gt;
gt; and ideas anyone?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()