Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jpspoerer
  • Content: Threads
  • Order by date
  1. jpspoerer

    Excel matches 2 values of ws#1 w/2 values of ss#2 to return one

    Problem; When values in column#1 & #2 of ws#1 match with values in column#1 & #2 of ws#2 the funtion returns the value in column#3 of ws#2 to column#5 of ws#1. Ex; If A2=10 & B2="L" in ws#1 then the funtion returns 700 to cell# E2. Wsheet#1; A B C D E 1 0 J...

Part and Inventory Search

Back
Top Bottom