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?

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

    software

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